Tasks to complete:
Create a new worksheet.
From the Product Name drop down select Create > Set....
Create
Set...
Select Condition from the top menu. Then By field:.
Condition
By field:
Change the Name of your condition to Bad Products.
Name
Change the Formula to look at where Profit Average < 0.
Profit Average < 0
You should now see a new set created at the bottom of the Data Menu in the left panel.
Quiz 1 below.
Try creating a new visual using your Set! Might be best to color based on the Set.
Nice job!
QUIZ QUESTION::
Determine what type of grouping is best for each scenario.
ANSWER CHOICES:
We want to look at which rows have shipping costs under 50. This should updated each time a new item ships for under 50.
We notice that there are a few outliers in a scatterplot of Price vs. Sales, and we want to look at how those items are related to one another in a plot of shipping costs.
We want to create 5 categories of profits - very high, high, medium, low, and very low performers.
Scenario
Grouping
Group
Neither a Group nor Set.
Set
Next Concept